ApiPivotDataField
Represents the ApiPivotDataField class.
Properties
Name | Type | Description |
---|---|---|
Function | DataConsolidateFunctionType | Returns or sets a function for the data field. |
Position | number | Returns or sets a value that represents the data field position within a category. |
Orientation | PivotFieldOrientationType | Returns a data field orientation value that represents the data field location in the specified pivot table report. |
Name | string | Returns or sets a value representing the object name. |
Value | string | Returns or sets a value representing the name of the specified data field in the pivot table report. |
Caption | string | Returns or sets a value that represents the label text for the data field. |
NumberFormat | string | null |
Index | number | Returns an index of the data field. |
PivotField | ApiPivotField | Returns the pivot field from which the data field was created. |
Methods
- Remove
- Move
- SetFunction
- GetFunction
- GetPosition
- SetPosition
- GetOrientation
- GetValue
- SetValue
- GetCaption
- SetCaption
- GetName
- SetName
- GetNumberFormat
- SetNumberFormat
- GetIndex
- GetPivotField
- ClearAllFilters
- ClearLabelFilters
- ClearManualFilters
- ClearValueFilters
- GetPivotItems
- Move
- Remove
- GetPosition
- SetPosition
- GetOrientation
- SetOrientation
- GetValue
- SetValue
- GetCaption
- SetCaption
- GetName
- SetName
- GetSourceName
- GetIndex
- GetTable
- GetParent
- GetLayoutCompactRow
- SetLayoutCompactRow
- GetLayoutForm
- SetLayoutForm
- GetLayoutPageBreak
- SetLayoutPageBreak
- GetShowingInAxis
- GetRepeatLabels
- SetRepeatLabels
- GetLayoutBlankLine
- SetLayoutBlankLine
- GetShowAllItems
- SetShowAllItems
- GetLayoutSubtotals
- SetLayoutSubtotals
- GetLayoutSubtotalLocation
- SetLayoutSubtotalLocation
- GetSubtotalName
- SetSubtotalName
- GetSubtotals
- SetSubtotals
- GetDragToColumn
- SetDragToColumn
- GetDragToRow
- SetDragToRow
- GetDragToData
- SetDragToData
- GetDragToPage
- SetDragToPage
- GetCurrentPage